Select b.name as Tabela,a.name as Coluna  from syscolumns a join sysobjects b on a.id = b.id 
where  a.name like '%Coluna%'
order by b.name


CREATE PROCEDURE LX_CADE_PARAMETRO @TEXTO VARCHAR(100)=NULL AS    
 IF SUBSTRING(@TEXTO,1,1) <> '%'    
  SELECT @TEXTO = '%'+@TEXTO    
 IF SUBSTRING(@TEXTO,DATALENGTH(@TEXTO),1) <> '%'    
  SELECT @TEXTO = @TEXTO+'%'    
 SELECT lower(parametro) FROM parametros WHERE parametro LIKE @texto